from sqlalchemy import create_engine
import pandas as pd

engine = create_engine('mysql+pymysql://root:11111111@localhost:3300/english')
data = pd.read_excel(r'C:\Users\weige\Desktop\2023陈正康考研英语基础词+生僻词.xlsx')
data.shape
data.to_sql('test2',engine,chunksize=100000,index=None)
print('存入成功！')
